DiagramNode Object

Multiple objects

Represents a node in a diagram.

Using the DiagramNode object

Use the AddNode method to add a node to a diagram or to a diagram node. This example assumes the third shape in the active worksheet is a diagram and adds a node to it.

Sub AddDiagramNode()
    ActiveSheet.Shapes(3).DiagramNode.Children.AddNode
End Sub

Use the Delete method to remove a node from a diagram or diagram node. This example assumes the second shape in the active worksheet is a diagram and removes the first node from it.

Sub DeleteDiagramNode()
    ActiveSheet.Shapes(2).DiagramNode.Children(1).Delete
End Sub

To return a DiagramNode object, use one of the following:

The DiagramNode object's AddNode, CloneNode, NextNode or PrevNode methods, or Root property
The DiagramNodeChildren collection's AddNode or Item methods, or FirstChild or LastChild properties

The DiagramNodes collection's Item method
The Shape object's or ShapeRange collection's DiagramNode property

A diagram node can terminate, or contain other child diagrams, child diagram nodes, or child shapes:

To refer to a child diagram, use the Diagram property.
To refer to an individual child diagram node, use the AddNode, CloneNode, NextNode or PrevNode methods, or Root property.
To refer to a collection of child diagram nodes, use the Children property.
To refer to a shape, use the Shape or TextShape properties.